package com.ag.lzw.dao;

import java.util.List;

import com.ag.dao.TbContactDAO;

public class LzwTbContactDAO extends TbContactDAO{

	public List getContactByDeptID(String DepyId){
		String hql = "from TbContact tbc left join fetch tbc.tbDept where tbc.tbDept.DId='"+DepyId+"'";
		return getHibernateTemplate().find(hql);
	}
	
	public List findDeptLeader(String D_ID){
		String hql = "from TbContact tbc where tbc.tbDept.DId='"+D_ID+"' and tbu.CIsleader";
		//return getHibernateTemplate().find(hql);
		return null;
	}
}
